﻿--delete from DBDictionaryService.DBInstrumentStaticData;	
--delete from DBDictionaryService.DBMarket;
--delete from DBDictionaryService.DBTickSizeRule;
--delete from DBDictionaryService.DBTickSizeRuleField;
--delete from DBDictionaryService.DBDictionaryService;

select * from DBDictionaryService.DBInstrumentStaticData order by Type, Code;	
select * from DBDictionaryService.DBMarket order by Path;
select * from DBDictionaryService.DBTickSizeRule order by Name;
select * from DBDictionaryService.DBTickSizeRuleField;
select * from DBDictionaryService.DBDictionaryService;

-- insert into DBDictionaryService.DBCurrencyPrice(ID,DBDictionaryServiceID,ForeignCurrency,CurrencyPrice) values (NEWID(),'5BA7381B-7F00-4BF7-9FB0-DE016E8C7A60','asd',1.7); 
-- ENABLE Trigger ALL ON ALL SERVER;

-- update DBDictionaryService.DBCurrencyPrice set CurrencyPrice=1.2 where ID='A5E14EC6-6EF4-47DB-BAB4-1405DBB78C0B'

-- select * from DBDictionaryService.DBMarket;	


--select * from DBDictionaryService.DBSector;
--select * from DBDictionaryService.DBCurrency;

--select * from DBDictionaryService.DBInstrumentStaticData;
--select * from DBDictionaryService.DBInstrumentStaticDataEquity;
-- select * from DBDictionaryService.DBInstrumentStaticDataEquityVanillaOption;

--select * from DBLiveObjects.DBConfigurationField;
--select * from DBLiveObjects.DBConfiguration;

--delete from DBDictionaryService.DBInstrumentStaticData;
--delete from DBLiveObjects.DBConfigurationField;
--delete from DBLiveObjects.DBConfiguration;
--delete from DBDictionaryService.DBTickSizeRule;
--delete from DBDictionaryService.DBTickSizeRuleField;

-- Insert some currencies
--declare @dictionary_id uniqueidentifier;
--select @dictionary_id = '3FD04FF4-C9FE-4E79-AB35-1D53D4FDB8CD'
--select * from DBDictionaryService.DBDictionaryService;	
--insert into DBDictionaryService.DBCurrencyPrice(ID,DBDictionaryServiceID,ForeignCurrency,CurrencyPrice) values (NEWID(), @dictionary_id, 'EUR',1.0); 
--insert into DBDictionaryService.DBCurrencyPrice(ID,DBDictionaryServiceID,ForeignCurrency,CurrencyPrice) values (NEWID(), @dictionary_id, 'USD',1.3); 
--select * from DBDictionaryService.DBCurrencyPrice;

update DBDictionaryService.DBInstrumentStaticData set PointValue=null, LotSize=null;